StudentAccountTransaction

EntityType | Independent
Logical Entity Name | StudentAccountTransaction
Default Table Name | SaTrans
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAccountTransaction Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
ClassSectionId |  | INTEGER | YES |
StudentAccountTransactionId |  | INTEGER | NO |
StudentId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
Source |  | CHAR(1) | NO |
Type |  | CHAR(1) | NO |
CampusId |  | INTEGER | YES |
BillingTransactionCode |  | CHAR(8) | NO |
TransactionNumber |  | NUMERIC(4, 0) | NO |
Description |  | VARCHAR(100) | YES |
Status |  | CHAR(1) | NO |
TransactionDate |  | DATETIME | NO |
PostDate |  | DATETIME | NO |
TransactionAmount |  | MONEY(19, 4) | NO |
PaymentType |  | CHAR(1) | YES |
DiscountAmount |  | MONEY(19, 4) | NO |
AmountPaid |  | MONEY(19, 4) | NO |
BatchNumber |  | CHAR(8) | NO |
StudentRevenueDetailId |  | INTEGER | NO |
PaymentPeriodId |  | INTEGER | NO |
AcademicYearSequence |  | NUMERIC(3, 0) | NO |
TermId |  | INTEGER | YES |
Reference |  | CHAR(75) | NO |
CheckNumber |  | VARCHAR(20) | NO |
StudentCreditCardId |  | INTEGER | YES |
ReceiptNumber |  | VARCHAR(16) | YES |
AppliedDate |  | DATETIME | YES |
IsSentBack |  | BIT | NO |
BankAccountId |  | INTEGER | YES |
BankDepositId |  | INTEGER | YES |
AdmissionsRepId |  | INTEGER | NO |
CommRate |  | MONEY(19, 4) | NO |
CommPaid |  | BIT | NO |
CommDate |  | DATETIME | YES |
IsPostedToGeneralLedger |  | BIT | NO |
PostAccount |  | NVARCHAR(100) | NO |
OffsetAccount |  | NVARCHAR(100) | NO |
StudentAwardId |  | INTEGER | YES |
PaidDisbursementId |  | INTEGER | YES |
RefundId |  | INTEGER | YES |
StudentAccountBatchBillingId |  | INTEGER | YES |
RefundCalculationId |  | INTEGER | YES |
CreatedByUserId |  | INTEGER | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
DepositId |  | INTEGER | YES |
CreditCardAuthorizationNumber |  | CHAR(10) | YES |
CreditCardDeclineCode |  | CHAR(10) | YES |
SyAddressID |  | INTEGER | YES |
SaQTBatchID |  | INTEGER | YES |
SA1098T |  | CHAR(1) | NO |
AchBatchFileId |  | INTEGER | YES |
ReceiptPrintedDate |  | DATETIME | YES |
CreditCardBatchTransactionId |  | INTEGER | YES |
CashDrawerSessionId |  | INTEGER | YES |
IsManualCheckExtract |  | BIT | YES |
CourseId |  | INTEGER | YES |
TuitionDiscountPolicyId |  | INTEGER | YES |
OriginalStudentAccountTransactionId |  | INTEGER | YES |
AgencyBranchCreditCardId |  | INTEGER | YES |
CheckStatus |  | CHAR(1) | NO |
CheckClearedDate |  | DATETIME | YES |
IsPreviousYear1098t |  | BIT | NO |
MerchantProcessingCode |  | VARCHAR(19) | YES |
StudentAcademicYearPaymentPeriodId |  | INTEGER | YES |
EFTNumber |  | VARCHAR(20) | YES |
EFTStatus |  | CHAR(1) | YES |
EFTClearedDate |  | DATETIME | YES |
CourseRefundPolicyId |  | INTEGER | YES |
CourseAmountToRetain |  | MONEY(19, 4) | YES |
RegistrationTermId |  | INTEGER | YES |
IsAutomatedProcess |  | BIT | NO |
StudentEnrollmentPeriodFeeId |  | INTEGER | YES |
IsGeneralLedgerStatusFlag |  | BIT | NO |
IsReissued |  | BIT | NO |
IsInPendingQueue |  | BIT | NO |
CashDrawerSessionId |  | INTEGER | YES |
StudentEnrollmentPeriodFeeId |  | INTEGER | YES |

StudentAccountTransaction Keys

Key Name | Key Type | Keys
SaTrans_SyAddressID_N_N_IDX | Inversion Entry | SyAddressID
SaTrans_CheckNo_N_N_IDX | Inversion Entry | CheckNumber
SaTrans_SaBillingBatchID_N_N_IDX | Inversion Entry | StudentAccountBatchBillingId
SaTrans_SaBillCode_N_N_IDX | Inversion Entry | BillingTransactionCode
SaTrans_Date_Sa1098T_Type_INCLUDE_N_N_idx | Inversion Entry | TransactionDate, SA1098T, Type
satrans_FaStudentAyPaymentPeriodId_N_N_IDX | Inversion Entry | StudentAcademicYearPaymentPeriodId
SaTrans_SaTuitionDiscountPolicyID_N_N_IDX | Inversion Entry | TuitionDiscountPolicyId
SaTrans_saCashDrawerSessionID_N_N_IDX | Inversion Entry | CashDrawerSessionId
SaTrans_SaACHBatchID_N_N_IDX | Inversion Entry | AchBatchFileId
SaTrans_BatchNo_N_N_IDX | Inversion Entry | BatchNumber
SaTrans_Date_N_N_IDX | Inversion Entry | TransactionDate
Nk_satrans_SyAddressId | Inversion Entry | SyAddressID
satrans_AdFeesId_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodFeeId
SaTrans_AmAgencyCCID_N_N_IDX | Inversion Entry | AgencyBranchCreditCardId
SaTrans_OriginalSaTransId_N_N_IDX | Inversion Entry | OriginalStudentAccountTransactionId
SaTrans_AdCourseID_N_N_IDX | Inversion Entry | CourseId
SaTrans_SyCampusID_Date_N_N_IDX | Inversion Entry | TransactionDate
SaTrans_AdEnrollId_AdTermId_SaBillCode_Source_Type_Amount_SaTransID_U_N_IDX | Alternate Key | BillingTransactionCode, Source, ClassSectionId
SaTrans_SyStudentID_Date_AdTermID_Type_N_N_IDX | Inversion Entry | TransactionDate, Type
SaTrans_SaTransID_U_C_IDX | PrimaryKey | StudentAccountTransactionId
SaTrans_AdEnrollId_Date_N_N_IDX | Inversion Entry | TransactionDate, ClassSectionId
SaTrans_CheckStatus_CheckClearedDate_CheckNo_SaBankAccountID_N_N_IDX | Inversion Entry | CheckStatus, CheckClearedDate, CheckNumber
Nk_SaTransAdClassschedID | Inversion Entry | ClassSectionId
SaTrans_SyCampusID_SaBankDepID_Type_Ref_Source_SaTransID_U_N_IDX | Alternate Key | Type, Reference, Source, ClassSectionId
SaTrans_SyStudentID_TranNum_N_N_IDX | Inversion Entry | TransactionNumber
SaTrans_AdTermID_Date_Sa1098T_N_N_IDX | Inversion Entry | TransactionDate, SA1098T
SaTrans_PostDate_Source_SaBankAccountID_SaTransID_U_N_IDX | Alternate Key | PostDate, Source, ClassSectionId
SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX | Alternate Key | Type, TransactionAmount, TransactionDate, ClassSectionId

StudentAccountTransaction Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
AchBatchFile | Non-Identifying | Zero or One to Zero or More |  |  |  | AchBatchFileId | NO
BankAccount | Non-Identifying | Zero or One to Zero or More |  |  |  | BankAccountId | NO
BankDeposit | Non-Identifying | Zero or One to Zero or More |  |  |  | BankDepositId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
CashDrawerSession | Non-Identifying | Zero or One to Zero or More |  |  |  | CashDrawerSessionId | NO
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
CreditCardBatchTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | CreditCardBatchTransactionId | NO
CashDrawerSession | Non-Identifying | Zero or One to Zero or More |  |  |  | CashDrawerSessionId | NO
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
Course | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseId | NO
StudentEnrollmentPeriodFee | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodFeeId | NO
AgencyBranchCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | AgencyBranchCreditCardId | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearPaymentPeriodId | NO
AchBatchFile | Non-Identifying | Zero or One to Zero or More |  |  |  | AchBatchFileId | NO
CourseRefundPolicy | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseRefundPolicyId | NO
PaidDisbursement | Non-Identifying | Zero or One to Zero or More |  |  |  | PaidDisbursementId | NO
Refund | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentAward | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAwardId | NO
StudentCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentCreditCardId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
StudentEnrollmentPeriodFee | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodFeeId | NO
StudentRevenueDetail | Non-Identifying | One To Zero or More |  |  |  | StudentRevenueDetailId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentAccountTransactionAppliedPayment | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaAutoStipendPaymentQueue | Non-Identifying | One To Zero or More |  |  |  |  | NO
DisbursementReceiptNotification | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
SaTransCourseAmount | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaTransFee | Non-Identifying | One To Zero or More |  |  |  |  | NO
AchBatchFileCompanyDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
CreditCardBatchTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRevenueDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
AchBatchFileCompanyDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
GeneralLedgerReleaseBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StipendSchedule | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionAppliedPayment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAccountTransaction Check Constraints

Check Constraint Name | CheckConstraint

StudentAccountTransaction Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAccountTransaction | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaTrans | NO |  |  |

StudentAccountTransaction Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ElectronicPaymentProcessing
Logical | LedgerCard_Billing
Logical | Refunds_Stipends
Logical | Revenue_GL_BankDeposit
Logical | StudentPayments_Collections
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

StudentAccountTransaction Data Movement Rules

Name | Type | Rule Text/Value